
INSERT INTO MSTB_INVENTORY_BALANCE( ID,    REGION_CODE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    ON_HAND_BALANCE,    MORTGAGED_QUANTITY,    SAFE_QUANTITY,    NOT_BE_USED_QUANTITY,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval,    '360' as REGION_CODE,    'UTC1' as WAREHOUSE_CODE ,    NULL,    NULL,    12345 as STOCK_ITEM_NUMBER,    100 as ON_HAND_BALANCE,    -7 as MORTGAGED_QUANTITY,    0 as SAFE_QUANTITY,    0 as NOT_BE_USED_QUANTITY,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO MSTB_INVENTORY_BALANCE( ID,    REGION_CODE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    ON_HAND_BALANCE,    MORTGAGED_QUANTITY,    SAFE_QUANTITY,    NOT_BE_USED_QUANTITY,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval,    '360' as REGION_CODE,    'UTC1' as WAREHOUSE_CODE ,    NULL,    NULL,    23456 as STOCK_ITEM_NUMBER,    200 as ON_HAND_BALANCE,    -6 as MORTGAGED_QUANTITY,    0 as SAFE_QUANTITY,    0 as NOT_BE_USED_QUANTITY,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO MSTB_INVENTORY_BALANCE( ID,    REGION_CODE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    ON_HAND_BALANCE,    MORTGAGED_QUANTITY,    SAFE_QUANTITY,    NOT_BE_USED_QUANTITY,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP) select MSSQ_INVENTORY_BALANCE_ID.nextval,    '360' as REGION_CODE,    'UTC2' as WAREHOUSE_CODE ,    NULL,    NULL,    12345 as STOCK_ITEM_NUMBER,    300 as ON_HAND_BALANCE,    -5 as MORTGAGED_QUANTITY,    0 as SAFE_QUANTITY,    0 as NOT_BE_USED_QUANTITY,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
